Returns the Soundex code for a string expression
Format
SQL Format:
SOUNDEX( expression )
ODBC Format:
{{ FN SOUNDEX( expression ) }}
Remarks
The scalar function SOUNDEX returns the soundex code for a string. The soundex code consists of a letter followed by three digits that provides an approximate phonetic representation of the string. This function is useful when finding names or words similar to other names or words.
Example:
The following example would return users with the name 'Steven', 'Stefan', 'Stephan' or other phonetic equivalents:
SELECT Name FROM CDBUser WHERE SOUNDEX(NAME) = SOUNDEX('Steven')